package com.qqqq.dao;

import com.qqqq.domain.SignIn;
import com.qqqq.domain.Student;

import java.sql.SQLException;
import java.util.List;

/**
 * @author 马松涛
 */
public interface StudentDao {
    //    通过学生学号获取学生信息
    Student getStudentByNum(int stuNumber) throws SQLException;

    int addStudentSign(int id) throws SQLException;

    List<SignIn> pageSignIn(int stuId, int pageNum, int pageSize) throws SQLException;

    int countSignIn(int id) throws SQLException;

    int addStudent(Student student) throws SQLException;

    int updateStudent(Student student) throws SQLException;

    int deleteStudent(int id) throws SQLException;

    Student getStudentById(int id) throws SQLException;

    List<Student> pageGetStudent(Integer stuMajorId, Integer stuClassId, int pageNum, int pageSize) throws SQLException;

    int countGetStudent(Integer stuMajorId, Integer stuClassId) throws SQLException;
}
